package com.hzhjhh.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.hzhjhh.dto.SaleDTO;
import com.hzhjhh.entity.Sale;

/**
 * @author 12083
 * @description 针对表【sm_sale(销售表)】的数据库操作Mapper
 * @createDate 2025-04-12 22:34:07
 * @Entity com.hzhjhh.entity.Sale
 */
public interface SaleMapper {

	public static String SQLFind1 = "select ProductID,ProductName,Number,Price,SaleDate,Number*Price from Sale where ProductID=?";
	public static String SQLFind2 = "select ProductID,ProductName,Number,Price,SaleDate,Number*Price from Sale";
	
	static final String insert4 = "insert sale (ProductID,SaleDate,Number,Price,Discount,VIP_ID,ProductName) values(?,?,?,?,?,?,?)";
	
	int batchInsertByEntity(@Param("saleList") List<Sale> saleList);
	
	List<Sale> selectListByCondition(@Param("dto") SaleDTO saleDto);
}
